<!--#include virtual="/Common/Config.asp" -->
<!--#include virtual="/Common/conn.asp" -->
<!--#include virtual="/2010admin/Check_IsLogin.asp" -->
<!--#include virtual="/Common/Function.asp" -->
<!--#include virtual="/2010admin/Common/Query_List_GetSQL.asp"-->
<!--#include file="Spot_Inc.asp" -->

<%
'==========================================
'**********	Modify  Start  ****************
dim TITLE,DISPFILD,PAGESIZE,SQL,HV
dim AddLabel,addURL,delURL,editURL,detailURL,detailURLsn
TITLE="景点查询"
DISPFILD="Spot_Name<景点名称,Spot_City<城市,Spot_IsHide_S<隐藏"
PAGESIZE="20"
HV="H"

AddLabel="增加新景点"
addURL="Spot_AE.asp"
delURL="Spot_Del.asp"
editURL="Spot_AE.asp"
detailURL_target="_blank"
Spot_Pic_URL="/2010admin/Gallery/Pic_Special_Edit.asp"

detailURLsn=1


'其他子操作列表 以#分隔
Other_Title = "图库"
Other_Url   = "Spot_Pic_Query.asp"

'置顶排序分类
Sort_Name="景点信息"

'设置置顶文件
Set_Top_URL = "Spot_Set_Top.asp"

'排序操作文件
Sort_Url 	= "Spot_Sort.asp"

Sort_Title  = "景点排序"



'=========================================================================

sql = "SELECT Spot_Id,Spot_City,Spot_Name, "&_
	  "	CASE Spot_IsHide "&_
	  " WHEN 1 THEN '是' " &_
	  " WHEN 0 THEN '否' " &_
      " END AS Spot_IsHide_S " &_

	  " FROM Spot_Info WHERE 1=1  "


Spot_Name   = reform("Spot_Name")
Spot_City   = reform("Spot_City")
Spot_Type   = reform("Spot_Type")

Spot_IsHide = reform("Spot_IsHide")

sql = LikeSql("Spot_Name",Spot_Name,sql)
sql = EqualSql("Spot_City",Spot_City,sql)
sql = EqualSql("Spot_Type",Spot_Type,sql)
sql = EqualSql("Spot_IsHide",Spot_IsHide,sql)

sql = sql & " Order By Spot_ID DESC "
'response.Write (sql)
'sql=""
'**********	Modify  Stop  *****************
'==========================================

If Request.form("previous")="上一页" Then PageNo=request.form("PageNo")-1
If Request.form("next")="下一页" Then PageNo=request.form("PageNo")+1
If Request.form("GotoPageNo")<>"" Then PageNo=request.form("GotoPageNo")
If Request.form("GotoPageNo2")<>"" Then	PageNo=request.form("GotoPageNo2")
%>

<HTML>
<HEAD>
<TITLE><%=Title%></TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link href="/2010admin/css/default.css" type="text/css" rel="stylesheet">
</HEAD>
<script language="javascript" src="/js/jquery.js"></script>
<script language="javascript" src="/2010admin/js/function.js"></script>
<BODY BGCOLOR="#FFFFFF"><br>
<form method="post" name="form" >
<TABLE cellSpacing=0 width="100%" border=0>
  <TBODY>
  <TR>
    <TD width="43%" align=left><FONT size=4><B><%=TITLE%></B></FONT>
	<%if addURL<>"" then%>
	<%=GetSpace(4)%><input type='button' class='inputbutton' value='<%=AddLabel%>' name='add' onClick="window.location.href='<%=addURL%>'">
	<%end if%>	
	<input type='button' class='inputbutton' value='排序' name='add' onClick="window.location.href='Spot_Sort.asp'">

	</TD>
    <TD width="37%" align=right>
      <TABLE cellSpacing=0 cellPadding=1 border=0>
        <TR>
		  <TD>景点名称</TD>
		  <TD>城市</TD>  
		  <TD>隐藏</TD>
        </TR>
        <TR>
          <TD><INPUT class=inputtext size=8 name="Spot_Name" Value="<%=Spot_Name%>"></TD>
		  <TD><% MySelected "Spot_City",Spot_City_List_Value,Spot_City_List_Value,"全部",Spot_City %></TD>
		  <TD><% MySelected "Spot_IsHide","1,0","是,否","全部",Spot_IsHide %></TD>
       </TR>
	   </TABLE>
	</TD>
    <TD vAlign=middle width="20%"> &nbsp;&nbsp;
      <INPUT type="submit" class="button" value="搜索" name="search">&nbsp;
	<br></TD>
  </TR>
  </TBODY>
</TABLE>
<HR SIZE=1>
<%
IF NOT Query_List_GetSQL(DISPFILD,SQL,PAGESIZE,HV,delURL,editURL,detailURL,detailURLsn) THEN
	Response.Write "<br><BR><center><font size=2><font color=#ff0000>程序执行错误！请与系统管理员联系！"
END If

Call conn_close()

%>
</FORM>
</BODY>
</HTML>

